Student Solution

-->

"Education is the most powerful weapon which you can use to change the world”
– Nelson Mandela

1 University

1 Course

1 Subject

Data Analysis With Spreadsheets -Discussion

Data Analysis With Spreadsheets -Discussion

Q Functions in Excel are grouped for easy reference. Locate the Statistical Functions group and select one of these functions. What is it? What does it do? Please include your research references in APA format.

View Related Questions

Solution Preview

The Formulas group in Excel consists of a set of formulas with different functions and objectives. The objective can be as simple as finding out the maximum/minimum value of the dataset by using the MAX()/MIN() formula, or be more complex as finding out the probability of the z-score with the use of the NORMSDIST() formula. For this discussion, I have selected three formulas from the Statistical Function group, COUNT (), COUNTA (), and COUNTIF ().